﻿/*
 * File nay se chua tat ca cac ham de thao tac den
 * CSDL trong chuong trinh
 */

using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;
using System;
using QLMB.ViewModels;
using QLMB.Infrastructure;

namespace QLMB.Models
{
    public interface IBookTicketRepository
    {
        #region Book Ticket
        IDictionary<string, string> LayDSSanbaydi();
        IEnumerable<CHUYENBAY> LayDSChuyenBay(DateTime Ngaydi, string Sanbaydi, string Sanbayden);
        string LayTenTP(string MaSB);
        string LayMaDuongBay(string NoiDi, string NoiDen); 
        #endregion
        #region Router Map
        List<SelectListItem> LayDSTP();
        List<SelectListItem> LayDSTPDen(string id);
        List<SelectListItem> LayDSTPDi(string id);
        List<SelectListItem> LayMaDB_BayThang(string sbdi, string sbden);
        List<SelectListItem> LayMaDB_HopTac(string sbdi, string sbden);
        int? LayThoiGianBay(string maDb);
        List<SelectListItem> LayDSMayBay(string loaidb, DateTime ngaydi, DateTime ngayden);
        List<SelectListItem> LayHanhTrinh(string sbdi, string sbden);
        List<FlightItem> LaySanBay(string madb);
        bool CreateFlight(FlightItem flight, string mamb, int loaicb);
        string CreateFlight(DateTime ngaydi, string madb);
        bool CreateFlight(FlightItem flight, string mamb, int loaicb, string macb, int stt);
        List<CHUYENBAY> ListAllFlight();

        FlightItem LayThongTinChuyenBay(CHUYENBAY cb);
        #endregion
    }
}